# backend/models.py
from sqlalchemy import Column, Integer, String
from database import Base

class GB(Base):
    __tablename__ = "gb"
    a25 = Column(Integer, primary_key=True, autoincrement=True, comment="药品 ID")
    a2  = Column(String(150), nullable=False, comment="药品名称")
    ybm = Column(String(30), comment="医保编码")
    a8  = Column(String(150), comment="生产企业")
    a9  = Column(String(150), comment="规格")
    a29 = Column(String(100), comment="批准文号")
    a21  = Column(String(20), comment="商品编码")
    a51  = Column(String(60), comment="处方")
    a53 = Column(String(60), comment="剂型")
    pic = Column(String(500), comment="图片路径（逗号分隔）")